Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Odbc > Re: Access issu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 2323 of 2443
Post > Topic >>

Re: Access issue again

by maps.on@[EMAIL PROTECTED] (Andreas) Mar 30, 2008 at 03:00 AM

Adrian Klaver wrote:
> On Saturday 29 March 2008 4:50 pm, Andreas wrote:
>   
>> Hi,
>>
>> whenever I ODBC link pg-tables into access I get this error in the log:
>> It's translated by me so it won't be the original english error text.
>> -----------------
>> 2008-03-30 00:28:45 CET db_sales user1 WARNING:  not standardconform
use
>> of \\ in  characterstring at char 264
>> 2008-03-30 00:28:45 CET db_sales user1 TIP:  Use the Syntax for
>> Escape-strings for Backslashes, e.g. E'\\'.
>> ------------------
>>
>> Besides this error the linked tables seem to work perfectly.
>> Whats wrong here?
>>     
>
> See this:
>
>
http://www.postgresql.org/docs/8.3/interactive/runtime-config-compatible.html
>   

OK I did a trace on the application and found that this message appears 
not for every linked table but just for those that have an underscore 
"_" within the table name, like  "my_table".
Nice to know but I can't help it.

I stuff the name and connectionstring into CreateTableDef and Access is 
supposed to do the rest.
Somehow Access 2000 feels like internally escaping the underscores, I
guess.

The same message appeares when I call RefreshLink on those TableDefs 
thingies.

In your answer you pointed out that the message could be suppressed. 
Though the issue will pop up again, as soon as the handling of those 
strings will get changed within the server.
Now what ?


Regards
Andreas

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
 




 3 Posts in Topic:
Access issue again
maps.on@[EMAIL PROTECTED]  2008-03-30 00:50:09 
Re: Access issue again
aklaver@[EMAIL PROTECTED]  2008-03-29 17:08:04 
Re: Access issue again
maps.on@[EMAIL PROTECTED]  2008-03-30 03:00:18 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 15:33:49 CST 2008.