Help Insert Code Vocher Ingame Mall Failed

[ganzki]

Haloo any one can help me with Insert Code Vocher Ingame Mall Failed this screen shoot of error

You must be registered to see links

thanks before

 

[baby011528]

double check F or A server has pop out error or not

 

[ganzki]

double check F or A server has pop out error or not

yes Agen server has pop up eror

CAgentSndGenVoc result 1DB:{call OdbcTopUp01('1682-5326','PYGx-WueJ-Z6mp','397','397','icute', ?)}DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'OdbcTopUp01'.CAgentTopUp result -1DB:{call OdbcTopUp01('1682-5326','PYGx-WueJ-Z6mp','698','698','icute', ?)}DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'OdbcTopUp01'.CAgentTopUp result -1

how to fix this thanks

 

[baby011528]

yes Agen server has pop up eror



how to fix this thanks

you missing procedure [OdbcTopUp01] thats why u unable to use voucher.

View attachment odbctopup01.zip

 

[ganzki]

you missing procedure [OdbcTopUp01] thats why u unable to use voucher.

View attachment 167500

in execute i have this eror sir

Msg 207, Level 16, State 1, Procedure OdbcTopUp1, Line 53Invalid column name 'PreClaimedBy'.Msg 207, Level 16, State 1, Procedure OdbcTopUp1, Line 63Invalid column name 'PreClaimedBy'.Msg 207, Level 16, State 1, Procedure OdbcTopUp1, Line 71Invalid column name 'PreClaimedBy'.

 

[loydtruita]

what client is this.
I think I know this.

 

[ganzki]

what client is this.
I think I know this.

im use CNDev Client EP10 sir ,

 

[loydtruita]

pm me in my FB

You must be registered to see links

 

[ganzki]

pm me in my FB

You must be registered to see links

i has to PM u sir

 

[baby011528]

in execute i have this eror sir

just share me your clean db.

 

[ganzki]

just share me your clean db.

this my user DB sir

You must be registered to see links

 

[baby011528]

this my user DB sir

You must be registered to see links

sorry for late reply.
this is what i done for you.
u can try it but i not sure will fix it or not.
View attachment RanUserBackup.zip

 

[ganzki]

Tq sir for the reply buat im still get eror like this

DB:{call OdbcTopUp01('5115-7789','2V7Z-Hu2t-QXAd','678','678','ganzki01', ?)}DB:42000, NativeError:8162, [Microsoft][SQL Server Native Client 10.0][SQL Server]The formal parameter "@szUserID" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.CAgentTopUp result -1

 

[baby011528]

Tq sir for the reply buat im still get eror like this

this i need to see your source to modify for it.
because i just simply took this procedure from another db.

 

[ganzki]

this i need to see your source to modify for it.
because i just simply took this procedure from another db.

ok how do i send it to you? and what files should I send or full source sir .. ?

 

[baby011528]

ok how do i send it to you? and what files should I send or full source sir .. ?

just upload to mediafire and post here.

 

[ganzki]

just upload to mediafire and post here.

this my source sir

You must be registered to see links

 

[baby011528]

this my source sir

You must be registered to see links

i noticed that your source call the procedure without timestamp, i removed the timestamp and replace via getdate
you try this db see.
View attachment RanUser fix odbc 0527.zip

 

[ganzki]

i noticed that your source call the procedure without timestamp, i removed the timestamp and replace via getdate
you try this db see.
View attachment 167514

TQ sir i will try this tt:

TQ sir i will try this tt:

---- Update------

TQ sir baby011528 top up work

 

[baby011528]

TQ sir i will try this tt:





---- Update------

TQ sir baby011528 top up work

you're welcome.