Odbc trace

Hi

I run odbc trace , thru ODBC Adliministrator > Tracing tab.

Is there a way to have the trace of

sql_parm_input, sql_c_wchar, sql_varchar of sqlbindparameter

For exmple :

MSACCESS 698-548 ENTER SQLBindParameter
HSTMT 07CD24F8
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 36
SWORD 0
PTR 0x67184BD4
SQLLEN 0
SQLLEN * 0x67184BD0

Thanks

Seems that odbcspy is doing the job ,

Found that odbcspy come with mdac sdk 2.0, but cannot find it

does anybody where can I download IT ?

|||

You can get the latest MDAC SDK from:

http://www.microsoft.com/downloads/details.aspx?familyid=5067faf8-0db4-429a-b502-de4329c8c850&displaylang=en

You could also search the http://www.microsoft.com website for "MDAC SDK".

odbc to progress db

I have users that thru and ODBC connection to my Sql2000 db attach tables
and query different information. Now they need to read data from a Progress
database on Unix to pull some values from a table. I have the ODBC driver
that allows me to connect to the Progress DB. Could I create a DB in SQL
that is nothing but views to the Progress tables?
I don't want to replicate the data down to Sql.
Any help or suggestions would be much appreciated.
Hi Andy
"Andy" wrote:

> I have users that thru and ODBC connection to my Sql2000 db attach tables
> and query different information. Now they need to read data from a Progress
> database on Unix to pull some values from a table. I have the ODBC driver
> that allows me to connect to the Progress DB. Could I create a DB in SQL
> that is nothing but views to the Progress tables?
> I don't want to replicate the data down to Sql.
>
> Any help or suggestions would be much appreciated.
>
If you have an odbc driver then you may be able to create a linked server
that will allow you users to query the remote database. See
http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
John
|||Do you still create a DB in SQL.
After you create the Link-Server how do the users run queries agisnt the
Progress(Unix) tables?
What does ther syntax look like?
Thanks..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
> Hi Andy
> "Andy" wrote:
> If you have an odbc driver then you may be able to create a linked server
> that will allow you users to query the remote database. See
> http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
> http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
>
> John
|||Hi
You don't need to create a separate database unless you want to keep access
away from your existing databases.
You can access the linked server using four part names such as:
SELECT col1, col2
FROM RemoteServer.RemoteDB..RemoteTable
See http://msdn2.microsoft.com/en-us/library/aa172676(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/ms187879.aspx
You can also use OPENQUERY see
http://msdn2.microsoft.com/en-us/library/aa276848(SQL.80).aspx
If you use stored procedures or views
http://msdn2.microsoft.com/en-us/library/aa258253(SQL.80).aspx to access the
remote database the users do not need to know where the data is.
John
"Andy" wrote:

> Do you still create a DB in SQL.
> After you create the Link-Server how do the users run queries agisnt the
> Progress(Unix) tables?
> What does ther syntax look like?
> Thanks..
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
>
>

odbc to progress db

I have users that thru and ODBC connection to my Sql2000 db attach tables
and query different information. Now they need to read data from a Progress
database on Unix to pull some values from a table. I have the ODBC driver
that allows me to connect to the Progress DB. Could I create a DB in SQL
that is nothing but views to the Progress tables?
I don't want to replicate the data down to Sql.
Any help or suggestions would be much appreciated.Hi Andy
"Andy" wrote:

> I have users that thru and ODBC connection to my Sql2000 db attach tables
> and query different information. Now they need to read data from a Progres
s
> database on Unix to pull some values from a table. I have the ODBC driver
> that allows me to connect to the Progress DB. Could I create a DB in SQL
> that is nothing but views to the Progress tables?
> I don't want to replicate the data down to Sql.
>
> Any help or suggestions would be much appreciated.
>
If you have an odbc driver then you may be able to create a linked server
that will allow you users to query the remote database. See
http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
John|||Do you still create a DB in SQL.
After you create the Link-Server how do the users run queries agisnt the
Progress(Unix) tables?
What does ther syntax look like?
Thanks..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
> Hi Andy
> "Andy" wrote:
>
> If you have an odbc driver then you may be able to create a linked server
> that will allow you users to query the remote database. See
> http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
> http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
>
> John|||Hi
You don't need to create a separate database unless you want to keep access
away from your existing databases.
You can access the linked server using four part names such as:
SELECT col1, col2
FROM RemoteServer.RemoteDB..RemoteTable
See http://msdn2.microsoft.com/en-us/library/aa172676(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/ms187879.aspx
You can also use OPENQUERY see
http://msdn2.microsoft.com/en-us/library/aa276848(SQL.80).aspx
If you use stored procedures or views
http://msdn2.microsoft.com/en-us/library/aa258253(SQL.80).aspx to access the
remote database the users do not need to know where the data is.
John
"Andy" wrote:

> Do you still create a DB in SQL.
> After you create the Link-Server how do the users run queries agisnt the
> Progress(Unix) tables?
> What does ther syntax look like?
> Thanks..
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
>
>

odbc to progress db

I have users that thru and ODBC connection to my Sql2000 db attach tables
and query different information. Now they need to read data from a Progress
database on Unix to pull some values from a table. I have the ODBC driver
that allows me to connect to the Progress DB. Could I create a DB in SQL
that is nothing but views to the Progress tables?
I don't want to replicate the data down to Sql.
Any help or suggestions would be much appreciated.Hi Andy
"Andy" wrote:
> I have users that thru and ODBC connection to my Sql2000 db attach tables
> and query different information. Now they need to read data from a Progress
> database on Unix to pull some values from a table. I have the ODBC driver
> that allows me to connect to the Progress DB. Could I create a DB in SQL
> that is nothing but views to the Progress tables?
> I don't want to replicate the data down to Sql.
>
> Any help or suggestions would be much appreciated.
>
If you have an odbc driver then you may be able to create a linked server
that will allow you users to query the remote database. See
http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
John|||Do you still create a DB in SQL.
After you create the Link-Server how do the users run queries agisnt the
Progress(Unix) tables?
What does ther syntax look like?
Thanks..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
> Hi Andy
> "Andy" wrote:
>> I have users that thru and ODBC connection to my Sql2000 db attach tables
>> and query different information. Now they need to read data from a
>> Progress
>> database on Unix to pull some values from a table. I have the ODBC driver
>> that allows me to connect to the Progress DB. Could I create a DB in SQL
>> that is nothing but views to the Progress tables?
>> I don't want to replicate the data down to Sql.
>>
>> Any help or suggestions would be much appreciated.
> If you have an odbc driver then you may be able to create a linked server
> that will allow you users to query the remote database. See
> http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
> http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
>
> John|||Hi
You don't need to create a separate database unless you want to keep access
away from your existing databases.
You can access the linked server using four part names such as:
SELECT col1, col2
FROM RemoteServer.RemoteDB..RemoteTable
See http://msdn2.microsoft.com/en-us/library/aa172676(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/ms187879.aspx
You can also use OPENQUERY see
http://msdn2.microsoft.com/en-us/library/aa276848(SQL.80).aspx
If you use stored procedures or views
http://msdn2.microsoft.com/en-us/library/aa258253(SQL.80).aspx to access the
remote database the users do not need to know where the data is.
John
"Andy" wrote:
> Do you still create a DB in SQL.
> After you create the Link-Server how do the users run queries agisnt the
> Progress(Unix) tables?
> What does ther syntax look like?
> Thanks..
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:1F399B30-FDAD-41CF-B05D-B56B48FFFBEE@.microsoft.com...
> > Hi Andy
> >
> > "Andy" wrote:
> >
> >> I have users that thru and ODBC connection to my Sql2000 db attach tables
> >> and query different information. Now they need to read data from a
> >> Progress
> >> database on Unix to pull some values from a table. I have the ODBC driver
> >> that allows me to connect to the Progress DB. Could I create a DB in SQL
> >> that is nothing but views to the Progress tables?
> >>
> >> I don't want to replicate the data down to Sql.
> >>
> >>
> >> Any help or suggestions would be much appreciated.
> >>
> > If you have an odbc driver then you may be able to create a linked server
> > that will allow you users to query the remote database. See
> > http://msdn2.microsoft.com/ru-ru/library/aa213778(SQL.80).aspx and
> > http://msdn2.microsoft.com/ru-ru/library/aa259589(SQL.80).aspx for more.
> >
> >
> > John
>
>

ODBC Timeout Error

Hi All,

I have one problem in connecting to SQL Server DSN thru Microsoft ODBC. The program was working properly and suddenly from few days, getting "-21472117871 [Microsoft][ODBC SQL Server Driver] Timeout Expired". And no new MS patches or SP installed recently.

I am using this in vbscript with the database connection with execute statement. Sometimes it takes 20-40 secs to get the resultset or sometimes timesout. What could be reason ? Is the database size, memory, transaction log size ?

For Example : Set adoAcctsRst = comDatabaseConnection.Execute("Services.dbo.AISSP_GetAccts '" & strUser & "' " )

Services is the Database, and AISSP_ is the stored procedure to execute with the input parameter as UserName. comDataBaseconnection is the command to connect to DSN.

Its getting timedout in this statement. What could be the solution ? Is it at the SQL Database or network connection ?

Appreciate for ur immedaite reply as this is urgent !!
Thanks in advanceWell it could be that the load on the DB is too much, it could be that the table needs a decent index on for the search criteria it could be load on the network.

You could also include your timeout on your connection when you connect to the database...

I would try the others first though,.. starting with the index...|||Do you have a baseline of what this stored procedure should take to run ? Have you run the stored procedure in query analyzer (how long does it take) ? If it taks a long time, copy the stored procedure content in qa and see if the duration is the same. If you had a recent jump/decline in the number of records that this stored procedure normally handles, this could also cause these problems.

ODBC system dsn problem

We have a client that is trying to connect to a SQL DB on
a Win2003 server (thru Citrix) using a system dsn. When a
user tries connecting using the system dsn in Crystal
Reports (or anyting else for that matter), they get the
following error: data source name not found and no default
driver specified.
If you go into the ODBC manager, the data source is there
but when you try to configure it you get - dsnname is not
an existing data source name. when you click on ok you
then get - invalid dsn.
If you log onto the workstation as a user with
administrator rights, none of these errors occur.
I have looked at our Citrix machine and 2 other customer
Citrix machines that are running the same software and I
realy don't see any differences. Our's and the other 2
customers work without the user having admin privleges.
Everything points to a permissions problem but whatever it
is, is alluding me. any help at this point is appreciated.
TIA,
BillODBC entries are controlled in the registry. I would suggest using
regedt32 or regedit (if you are on Win 20003/XP), and go to
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and try adding full control permissions
for the affected user/groups, replacing the values in the subkeys. Good
luck.
****************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
This posting is provided "as is" with
no warranties and confers no rights.
****************************************
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Thanks Andy. I received a similar response on a SQL Mail
list that I posted to. The registry seems to have been the
problem. I changed the permissions giving access to the
everyone group. I then tested going into the odbc
configuration as one of the users that was having problems
and I no longer get an error. I have the customer testing
an Access program that has linked tables using the system
dsn.
Bill

>--Original Message--
>ODBC entries are controlled in the registry. I would
suggest using
>regedt32 or regedit (if you are on Win 20003/XP), and go
to
>HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and try adding full
control permissions
>for the affected user/groups, replacing the values in the
subkeys. Good
>luck.
> ****************************************
>Andy S.
>MCSE NT/2000, MCDBA SQL 7/2000
>andymcdba1@.NOMORESPAM.yahoo.com
>Please remove NOMORESPAM before replying.
>This posting is provided "as is" with
>no warranties and confers no rights.
> ****************************************
>*** Sent via Developersdex http://www.examnotes.net
***
>Don't just participate in USENET...get rewarded for it!
>.
>

ODBC problem

I have been trying to reconfigure specific System DSN's in the ODBC System A
dministrator thru the Control Panel. When I click on Add or Configure button
s, nothing happes. I have tried this at the Domain and Local level with the
same results. I have tried
it as a user and administrator with nothing. This is a W2k PC with SP4 (just
updated) which had MDAC 2.7. I tried to update to MDAC 2.8 which did not so
lve the problem. I reinstalled the MDAC 2.7 and the result was the same. Wha
t could be stopping the Ad
ding or Configuring process from the ODBC Control Panel?
Thanks for any help in this matter.Hello,
double click on your existing dsn and see if configure window is appear
or not.
tell me .
Thanks,
Warm Regards,
Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!